Columns
Indexes
Grants
Dependencies
Details
Columns
Indexes
Grants
Dependencies
Details
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS |
---|---|---|---|---|---|
OBJ | VARCHAR2(20 BYTE) | No | null | 1 | null |
ID | VARCHAR2(100 BYTE) | Yes | null | 2 | null |
TITLE | VARCHAR2(400 BYTE) | Yes | null | 3 | null |
CREATED_ON | DATE | Yes | null | 4 | null |
CREATED_ON_FY | NUMBER | Yes | null | 5 | null |
CLOSED_ON | DATE | Yes | null | 6 | null |
CLOSED_ON_FY | NUMBER | Yes | null | 7 | null |
DAYS_OPEN | NUMBER | Yes | null | 8 | null |
STATUS | VARCHAR2(100 BYTE) | Yes | null | 9 | null |
OWNING_UNIT | VARCHAR2(400 BYTE) | Yes | null | 10 | null |
INCIDENTS | VARCHAR2(4000 BYTE) | Yes | null | 11 | null |
LEAD | VARCHAR2(400 BYTE) | Yes | null | 12 | null |
SUPPORT_PERSONNEL | VARCHAR2(4000 BYTE) | Yes | null | 13 | null |
ASSOCIATIONS_COUNT | NUMBER | Yes | null | 14 | null |
ATTACHMENTS_COUNT | NUMBER | Yes | null | 15 | null |
NOTES_COUNT | NUMBER | Yes | null | 16 | null |
SUBJECT_COUNT | NUMBER | Yes | null | 17 | null |
WITNESS_COUNT | NUMBER | Yes | null | 18 | null |
VICTIM_COUNT | NUMBER | Yes | null | 19 | null |
INCIDENTAL_COUNT | NUMBER | Yes | null | 20 | null |
NEXT_DUE_DATE | DATE | Yes | null | 21 | null |
FINAL_DUE_DATE | DATE | Yes | null | 22 | null |
FINAL_DUE_DATE_FY | NUMBER | Yes | null | 23 | null |
FINAL_DUE_DATE_MET | VARCHAR2(3 BYTE) | Yes | null | 24 | null |
INDEX_OWNER | INDEX_NAME | COLUMNS | UNIQUENESS | STATUS | INDEX_TYPE | TEMPORARY | PARTITIONED | FUNCIDX_STATUS | COLUMN_EXPRESSION | JOIN_INDEX |
---|
PRIVILEGE | GRANTEE | GRANTABLE | GRANTOR | OBJECT_NAME |
---|
OBJECT_ID | OWNER | OBJECT_TYPE | OBJECT_NAME | STATUS | TYPE_LINK |
---|
References
NAME | VALUE |
---|---|
CREATED | 24-APR-23 |
LAST_DDL_TIME | 07-FEB-25 |
OWNER | QART |
MVIEW_NAME | MV_SIIA_ANALYSIS |
CONTAINER_NAME | MV_SIIA_ANALYSIS |
QUERY | SELECT DISTINCT O.SID OBJ, O.ID ID, O.TAGLINE TITLE, O.CREATED_ON CREATED_ON, O.CREATED_ON_FY CREATED_ON_FY, CASE WHEN S1.DISPLAY = 'Closed' THEN S.STARTED_ON ELSE NULL END AS CLOSED_ON, CASE WHEN S1.DISPLAY = 'Closed' THEN S.STARTED_ON_FY ELSE NULL END AS CLOSED_ON_FY, CASE WHEN S1.DISPLAY = 'Closed' THEN (TRUNC (S.STARTED_ON) - TRUNC (O.CREATED_ON)) ELSE (TRUNC (SYSDATE) - TRUNC (O.CREATED_ON)) END DAYS_OPEN, S1.DISPLAY STATUS, OU.SH_DISPLAY OWNING_UNIT, LISTAGG (REF.DISPLAY, ', ') WITHIN GROUP (ORDER BY REF.DISPLAY) INCIDENTS, L.SH_DISPLAY LEAD, SO.SH_DISPLAY SUPPORT_PERSONNEL, NVL(FROM_ASSOC_COUNT.CNT, 0) + NVL(TO_ASSOC_COUNT.CNT, 0) ASSOCIATIONS_COUNT, NVL(ATTACH_COUNT.CNT, 0) ATTACHMENTS_COUNT, NVL(NOTES_CNT.CNT, 0) NOTES_COUNT, NVL(SUBJ_COUNT.CNT, 0) SUBJECT_COUNT, NVL(WIT_COUNT.CNT, 0) WITNESS_COUNT, NVL(VIC_COUNT.CNT, 0) VICTIM_COUNT, NVL(INC_COUNT.CNT, 0) INCIDENTAL_COUNT, O.NEXT_DUE_DATE, O.FINAL_DUE_DATE, O.FINAL_DUE_DATE_FY, CASE WHEN S1.DISPLAY = 'Closed' AND TRUNC (S.STARTED_ON) <= TRUNC (O.FINAL_DUE_DATE) THEN 'Yes' ELSE 'No' END FINAL_DUE_DATE_MET FROM MV_ACM_OBJ O INNER JOIN MV_ACM_OBJ_TYPE OT ON O.OBJ_TYPE = OT.SID AND OT.OBJ_TYPE_CODE = 'FILE.ANALYSIS' LEFT JOIN MV_F_ANALYSIS ANALYSIS ON O.SID = ANALYSIS.OBJ LEFT JOIN MV_F_ANALYSIS_INC ANALYSIS_INC ON ANALYSIS.SID = ANALYSIS_INC.ANALYSIS_FILE LEFT JOIN MV_ACM_REFERENCE REF ON REF.REF_KEY = ANALYSIS_INC.MATTER_INVEST LEFT JOIN MV_ACM_STATUS_HISTORY S ON O.SID = S.OBJ AND S.COMPLETED_ON IS NULL LEFT JOIN MV_ACM_STATUS S1 ON S1.SID = S.STATUS LEFT JOIN MV_ACM_PLACE V ON O.SID = V.OBJ LEFT JOIN V_CURR_OBJ_OWNING_UNIT OU ON O.SID = OU.OBJ LEFT JOIN V_CURR_OBJ_LEAD_PERS L ON O.SID = L.OBJ LEFT JOIN (SELECT OBJ, LISTAGG (SH_DISPLAY, ';' || CHR (13)) WITHIN GROUP (ORDER BY SH_DISPLAY) OVER (PARTITION BY OBJ) SH_DISPLAY FROM V_CURR_OBJ_SUPPORT_OFFICER) SO ON O.SID = SO.OBJ LEFT JOIN (SELECT FROM_OBJ, COUNT (1) AS CNT FROM MV_ACM_ASSOCIATION GROUP BY FROM_OBJ) FROM_ASSOC_COUNT ON FROM_ASSOC_COUNT.FROM_OBJ = O.SID LEFT JOIN (SELECT TO_OBJ, COUNT (1) AS CNT FROM MV_ACM_ASSOCIATION GROUP BY TO_OBJ) TO_ASSOC_COUNT ON TO_ASSOC_COUNT.TO_OBJ = O.SID LEFT JOIN (SELECT OBJ, COUNT (1) AS CNT FROM MV_ACM_ATTACHMENT GROUP BY OBJ) ATTACH_COUNT ON ATTACH_COUNT.OBJ = O.SID LEFT JOIN (SELECT OBJ, COUNT (1) AS CNT FROM MV_ACM_NOTE GROUP BY OBJ) NOTES_CNT ON NOTES_CNT.OBJ = O.SID LEFT JOIN (SELECT OBJ, COUNT (1) AS CNT FROM MV_PARTIC_INVOLVEMENT WHERE INVOLVEMENT_ROLE IN (SELECT SID FROM MV_PARTIC_ROLE_TYPE WHERE CODE = 'SUBJECT') GROUP BY OBJ) SUBJ_COUNT ON SUBJ_COUNT.OBJ = O.SID LEFT JOIN (SELECT OBJ, COUNT (1) AS CNT FROM MV_PARTIC_INVOLVEMENT WHERE INVOLVEMENT_ROLE IN (SELECT SID FROM MV_PARTIC_ROLE_TYPE WHERE CODE = 'WITNESS') GROUP BY OBJ) WIT_COUNT ON WIT_COUNT.OBJ = O.SID LEFT JOIN (SELECT OBJ, COUNT (1) AS CNT FROM MV_PARTIC_INVOLVEMENT WHERE INVOLVEMENT_ROLE IN (SELECT SID FROM MV_PARTIC_ROLE_TYPE WHERE CODE = 'VICTIM') GROUP BY OBJ) VIC_COUNT ON VIC_COUNT.OBJ = O.SID LEFT JOIN (SELECT OBJ, COUNT (1) AS CNT FROM MV_PARTIC_INVOLVEMENT WHERE INVOLVEMENT_ROLE IN (SELECT SID FROM MV_PARTIC_ROLE_TYPE WHERE CODE = 'INCDNTL') GROUP BY OBJ) INC_COUNT ON INC_COUNT.OBJ = O.SID GROUP BY O.SID, O.ID, OT.DISPLAY, O.TAGLINE, O.CREATED_ON, S1.DISPLAY, OU.SH_DISPLAY, L.SH_DISPLAY, SO.SH_DISPLAY, NVL(FROM_ASSOC_COUNT.CNT, 0) + NVL(TO_ASSOC_COUNT.CNT, 0), NVL(ATTACH_COUNT.CNT, 0), NVL(NOTES_CNT.CNT, 0), NVL(SUBJ_COUNT.CNT, 0), NVL(WIT_COUNT.CNT, 0), NVL(VIC_COUNT.CNT, 0), NVL(INC_COUNT.CNT, 0), O.CREATED_ON_FY, O.NEXT_DUE_DATE, O.FINAL_DUE_DATE, O.FINAL_DUE_DATE_FY, CASE WHEN S1.DISPLAY = 'Closed' AND TRUNC (S.STARTED_ON) <= TRUNC (O.FINAL_DUE_DATE) THEN 'Yes' ELSE 'No' END, S1.DISPLAY, 'Closed', TRUNC (S.STARTED_ON), CASE WHEN S1.DISPLAY = 'Closed' THEN (TRUNC (S.STARTED_ON) - TRUNC (O.CREATED_ON)) ELSE (TRUNC (SYSDATE) - TRUNC (O.CREATED_ON)) END, S.STARTED_ON, TRUNC (O.FINAL_DUE_DATE), O.FINAL_DUE_DATE, 'Yes', 'No', S1.DISPLAY, 'Closed', TRUNC (S.STARTED_ON), S.STARTED_ON, S.STARTED_ON, TRUNC (O.FINAL_DUE_DATE), O.FINAL_DUE_DATE, O.FINAL_DUE_DATE, 'Yes', 'No', CASE WHEN S1.DISPLAY = 'Closed' THEN S.STARTED_ON ELSE NULL END, S1.DISPLAY, 'Closed', S.STARTED_ON, NULL, CASE WHEN S1.DISPLAY = 'Closed' THEN S.STARTED_ON_FY ELSE NULL END, S1.DISPLAY, 'Closed', S.STARTED_ON_FY, NULL |
QUERY_LEN | 6069 |
UPDATABLE | N |
UPDATE_LOG | null |
MASTER_ROLLBACK_SEG | null |
MASTER_LINK | null |
REWRITE_ENABLED | N |
REWRITE_CAPABILITY | NONE |
REFRESH_MODE | DEMAND |
REFRESH_METHOD | FORCE |
BUILD_MODE | IMMEDIATE |
FAST_REFRESHABLE | NO |
LAST_REFRESH_TYPE | COMPLETE |
LAST_REFRESH_DATE | 07-FEB-25 |
LAST_REFRESH_END_TIME | 07-FEB-25 |
STALENESS | UNUSABLE |
AFTER_FAST_REFRESH | NA |
UNKNOWN_PREBUILT | N |
UNKNOWN_PLSQL_FUNC | N |
UNKNOWN_EXTERNAL_TABLE | N |
UNKNOWN_CONSIDER_FRESH | N |
UNKNOWN_IMPORT | N |
UNKNOWN_TRUSTED_FD | N |
COMPILE_STATE | VALID |
USE_NO_INDEX | N |
STALE_SINCE | null |
NUM_PCT_TABLES | 0 |
NUM_FRESH_PCT_REGIONS | null |
NUM_STALE_PCT_REGIONS | null |
SEGMENT_CREATED | YES |
EVALUATION_EDITION | null |
UNUSABLE_BEFORE | null |
UNUSABLE_BEGINNING | null |
DEFAULT_COLLATION | USING_NLS_COMP |
ON_QUERY_COMPUTATION | N |
DUPLICATED | N |
SHARDED | N |